<?php 
// accept mm/dd/yy date string and convert to mysql format
function _mysql_format_date($date)
{
	list($day, $month, $year) = explode('/', $date);
	return sprintf('%04d-%02d-%02d', $year, $month, $day);
}